M&B-2025-31 Database Analyst 1 (Internal Posting)
Trenton, NJ
Full Time
Management & Budget
Mid Level
Open to: Division-Wide
Work Week: NL (35-hour) Work Week
Salary: (P27) $84,547.83- $ 124,365.93
Opening Date: December 5, 2025
Closing Date: December 19, 2025
Existing Vacancies: 1
Program/Location
Department of Environmental Protection
Management and Budget
Division of Information Technology
Bureau of IT Operations
401 East State Street
Trenton, NJ 08625
Scope of Eligibility
Open to permanent employees in a competitive title who works for the Division of Information Technology and meet the requirements below.
Description
Under general supervision in one of the Data Centers, is responsible for the analysis, physical design, coding, testing, migration, and implementation of databases in various platforms; coordinates efforts with systems and programming staff assigned to application development projects; creates and updates data dictionaries for applications; does other related duties as required.
Specific to the Position
Serve as the primary Database Analyst/Administrator (DBA) for assigned database systems and backup DBA for systems covered by other DBA staff. Manage the OS on the Linux database servers and ensure appropriate patch levels for the Linux OS, Oracle, SQLServer, MariaDB and other RDBMS software. Determine the logical and physical organization of data to meet storage and processing requirements of systems, document the design. Review data requirements for application systems and defines appropriate database/data dictionary structures. Code, test, and implement specialized routines for loading, accessing, retrieving, and updating for database applications. Manage redundancy and backup implementations. Manage resource allocations among multiple database servers to ensure efficient utilization of resources and monitor licensing compliance for software and applications. Test and advise on database version upgrades. Provision testing and development of databases as necessary.
Preferred Skill Set
Preference will be given to candidates with experience in Oracle RDBMS, Microsoft SQL Server, MySQL/MariaDB and/or other enterprise RDBMS solutions, knowledge of Structured Query Language (SQL) and advanced database management concepts, experience in RMAN backup, Data Guard, Transparent Data Encryption, Label Security, and Enterprise Manager(OEM), familiarity with Windows Operating System and Linux, as well as maintenance of essential records, documentations, and files.
Requirements
EDUCATION:
Graduation from an accredited college or university with an Associate's degree in Computer Science, Information Technology, or a closely related field.
EXPERIENCE:
Three (3) years of systems analysis, applications programming, design, systems programming and/or database administration or analysis experience in the data processing field, one (1) year of which shall have been in database design, analysis, and/or implementation.
NOTE: A general Bachelor's degree can be substituted for one (1) year of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
NOTE: A specific Bachelor's degree in Computer Science, Information Technology, or a closely related field can be substituted for two (2) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
NOTE: A Master's degree in Computer Science, Information Technology, or a closely related field may be substituted for three (3) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
Special Note Substituting Experience for Education:
Experience in the study of work methods and processes, the analysis of varied types of data, the design and preparation of systems and programs, the operation of multi-tiered computer systems and work in the data processing support areas of reporting or reliability support may be substituted for the required education on a year-for-year basis with thirty (30) semester hour credits being equal to one (1) year of experience.
NOTE: Evidence of formal training in Computer Science or Information Technology received from or evaluated by an accredited institution of higher learning may be submitted with your application. Applicants must provide documentation from the accredited institution that clearly outlines the training course(s) that are acceptable and the corresponding number of credit hours for the training to be accepted. In-house courses (such as training provided on the job or through the appointing authority) will not be accepted.
NOTE: All U.S. degrees and transcripts must be from an accredited college or university. All foreign degrees and transcripts must be evaluated for accreditation by a recognized evaluation service by the closing date of this posting. Failure to provide documentation may result in ineligibility.
License
Appointees will be required to possess a driver's license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform the essential duties of the position.
Veteran's Preference
To qualify for New Jersey Veteran's Preference/status, you must establish Veteran's Preference through the Department of Military and Veteran's Affairs. Please submit proof of your Veteran's Preference along with your resume as indicated. For more information, please visit https://www.nj.gov/military/veterans/services/civil-service-preference/
Residency
All persons newly hired on or after September 1, 2011, have one year from the date of employment to establish, and then maintain principal residence in the State of New Jersey subject to the provisions of N.J.S.A. 52:14-7 (L.2011, Chapter 70), also known as the “New Jersey First Act”.
Benefits
As a New Jersey State Department, NJDEP offers a comprehensive benefits package that includes:
*Pursuant to the State/Department's policy, procedures, and/or guidelines.
Authorization to Work
Selected candidates must be authorized to work in the United States per the Department of Homeland Security, United States Citizenship, and Immigration Services regulations. NOTE: The State of New Jersey does not provide sponsorship for citizenship to the United States.
Equal Opportunity Employment
The State of New Jersey seeks to increase the richness and diversity of its workforce, and in doing so, become the employer of choice for all people seeking to work in State Government. To evaluate the effectiveness of our efforts to attract and employ a diverse workforce, applicants are asked to voluntarily answer a few brief questions on the NJ Affirmative Action Information Form. All information is considered confidential and will be filed separately with the agency's affirmative action officer. This information will not be part of your application for employment and will not be considered in any hiring decision.
Work Week: NL (35-hour) Work Week
Salary: (P27) $84,547.83- $ 124,365.93
Opening Date: December 5, 2025
Closing Date: December 19, 2025
Existing Vacancies: 1
Program/Location
Department of Environmental Protection
Management and Budget
Division of Information Technology
Bureau of IT Operations
401 East State Street
Trenton, NJ 08625
Scope of Eligibility
Open to permanent employees in a competitive title who works for the Division of Information Technology and meet the requirements below.
Description
Under general supervision in one of the Data Centers, is responsible for the analysis, physical design, coding, testing, migration, and implementation of databases in various platforms; coordinates efforts with systems and programming staff assigned to application development projects; creates and updates data dictionaries for applications; does other related duties as required.
Specific to the Position
Serve as the primary Database Analyst/Administrator (DBA) for assigned database systems and backup DBA for systems covered by other DBA staff. Manage the OS on the Linux database servers and ensure appropriate patch levels for the Linux OS, Oracle, SQLServer, MariaDB and other RDBMS software. Determine the logical and physical organization of data to meet storage and processing requirements of systems, document the design. Review data requirements for application systems and defines appropriate database/data dictionary structures. Code, test, and implement specialized routines for loading, accessing, retrieving, and updating for database applications. Manage redundancy and backup implementations. Manage resource allocations among multiple database servers to ensure efficient utilization of resources and monitor licensing compliance for software and applications. Test and advise on database version upgrades. Provision testing and development of databases as necessary.
Preferred Skill Set
Preference will be given to candidates with experience in Oracle RDBMS, Microsoft SQL Server, MySQL/MariaDB and/or other enterprise RDBMS solutions, knowledge of Structured Query Language (SQL) and advanced database management concepts, experience in RMAN backup, Data Guard, Transparent Data Encryption, Label Security, and Enterprise Manager(OEM), familiarity with Windows Operating System and Linux, as well as maintenance of essential records, documentations, and files.
Requirements
EDUCATION:
Graduation from an accredited college or university with an Associate's degree in Computer Science, Information Technology, or a closely related field.
EXPERIENCE:
Three (3) years of systems analysis, applications programming, design, systems programming and/or database administration or analysis experience in the data processing field, one (1) year of which shall have been in database design, analysis, and/or implementation.
NOTE: A general Bachelor's degree can be substituted for one (1) year of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
NOTE: A specific Bachelor's degree in Computer Science, Information Technology, or a closely related field can be substituted for two (2) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
NOTE: A Master's degree in Computer Science, Information Technology, or a closely related field may be substituted for three (3) years of experience in systems analysis, application programming, design, systems programming, and/or database administration or analysis.
Special Note Substituting Experience for Education:
Experience in the study of work methods and processes, the analysis of varied types of data, the design and preparation of systems and programs, the operation of multi-tiered computer systems and work in the data processing support areas of reporting or reliability support may be substituted for the required education on a year-for-year basis with thirty (30) semester hour credits being equal to one (1) year of experience.
NOTE: Evidence of formal training in Computer Science or Information Technology received from or evaluated by an accredited institution of higher learning may be submitted with your application. Applicants must provide documentation from the accredited institution that clearly outlines the training course(s) that are acceptable and the corresponding number of credit hours for the training to be accepted. In-house courses (such as training provided on the job or through the appointing authority) will not be accepted.
NOTE: All U.S. degrees and transcripts must be from an accredited college or university. All foreign degrees and transcripts must be evaluated for accreditation by a recognized evaluation service by the closing date of this posting. Failure to provide documentation may result in ineligibility.
License
Appointees will be required to possess a driver's license valid in New Jersey only if the operation of a vehicle, rather than employee mobility, is necessary to perform the essential duties of the position.
Veteran's Preference
To qualify for New Jersey Veteran's Preference/status, you must establish Veteran's Preference through the Department of Military and Veteran's Affairs. Please submit proof of your Veteran's Preference along with your resume as indicated. For more information, please visit https://www.nj.gov/military/veterans/services/civil-service-preference/
Residency
All persons newly hired on or after September 1, 2011, have one year from the date of employment to establish, and then maintain principal residence in the State of New Jersey subject to the provisions of N.J.S.A. 52:14-7 (L.2011, Chapter 70), also known as the “New Jersey First Act”.
Benefits
As a New Jersey State Department, NJDEP offers a comprehensive benefits package that includes:
- Paid Benefit Leave
- Holiday Pay
- Alternative Workweek Program*
- Telework*
- Pension
- Deferred Compensation
- Health Benefits (medical, prescription drug, dental & vision care) and Life Insurance
- Flexible and Health Spending Accounts (FSA/HSA)
- Commuter Tax Savings Program
- Public Service Loan Forgiveness (PSLF)
- Tuition Reimbursement*
*Pursuant to the State/Department's policy, procedures, and/or guidelines.
Authorization to Work
Selected candidates must be authorized to work in the United States per the Department of Homeland Security, United States Citizenship, and Immigration Services regulations. NOTE: The State of New Jersey does not provide sponsorship for citizenship to the United States.
Equal Opportunity Employment
The State of New Jersey seeks to increase the richness and diversity of its workforce, and in doing so, become the employer of choice for all people seeking to work in State Government. To evaluate the effectiveness of our efforts to attract and employ a diverse workforce, applicants are asked to voluntarily answer a few brief questions on the NJ Affirmative Action Information Form. All information is considered confidential and will be filed separately with the agency's affirmative action officer. This information will not be part of your application for employment and will not be considered in any hiring decision.
DEP Notices of Vacancy have a 4:00 p.m. deadline on the closing date. When filing for these opportunities, please be sure to have your letter of interest and credentials sent electronically before 4 p.m. on the closing date.
The New Jersey Department of Environmental Protection is an Equal Opportunity Employer and is committed to inclusive hiring and a diverse workforce. We strongly encourage people from all backgrounds to apply. Accommodations under ADA will be provided upon request.
Apply for this position
Required*